1.) How many of each item are being lent per quarter and week?

a) Overall by Week and Item Breakdown

Fall 2017-2018 Item Checkouts
Item Type Frequency
Iphone 13770
New macbook charger 13418
Expo 3885
Headset 3562
Wall 3049
VGA 2744
Old macbook charger 2414
HDMI 2354
Android 1999
Mouse 1055
USBC macbook charger 946
Non-graphing calc 910
VGA cable 625
Hyperjuice 443
Superdrive 211
Graphing calc 208
Livescribe pen 21
Fall 2017-2018 Item Checkouts by Week
0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week
Android 28 120 122 151 169 169 204 189 141 206 243 149
Expo 45 139 191 310 436 351 387 379 229 269 402 450
Graphing calc 1 6 9 13 28 25 22 22 19 4 17 33
HDMI 19 125 130 176 228 244 201 224 161 256 320 154
Headset 48 189 206 291 340 301 281 293 200 319 450 368
Hyperjuice 5 38 38 33 44 45 39 41 34 37 53 34
Iphone 239 873 1023 1135 1214 1237 1229 1112 952 1279 1595 874
Livescribe pen 12 6 0 0 0 0 1 0 0 2 0 0
Mouse 20 63 79 80 80 94 83 92 64 93 142 94
New macbook charger 155 887 1052 1181 1253 1205 1152 1180 883 1205 1538 838
Non-graphing calc 3 10 20 55 131 100 101 76 84 23 70 199
Old macbook charger 24 158 227 238 226 247 204 207 179 196 285 122
Superdrive 6 10 21 18 20 22 12 17 20 22 17 6
USBC macbook charger 5 51 40 55 96 96 102 83 52 131 160 75
VGA 41 215 252 274 271 237 240 258 158 309 233 43
VGA cable 12 71 57 73 56 48 57 59 41 72 44 9
Wall 57 193 194 224 224 211 253 253 196 260 355 216

b) Fall 2017 by Week

Fall 2017 Item Checkouts
Item Type Frequency
New macbook charger 2943
Iphone 1874
Expo 1086
Headset 808
VGA 691
Old macbook charger 668
HDMI 534
Android 506
Mouse 299
Wall 263
Non-graphing calc 237
VGA cable 188
Hyperjuice 108
Graphing calc 62
Superdrive 34
Fall 2017 Item Checkouts by Week
0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week
Android 9 22 20 31 48 45 64 60 36 67 67 37
Expo 29 47 65 105 140 92 113 122 56 67 116 134
Graphing calc 1 3 5 2 4 6 8 7 4 2 8 12
HDMI 4 31 43 43 48 67 53 56 20 65 64 40
Headset 20 30 36 75 86 74 65 104 37 87 107 87
Hyperjuice 5 3 1 2 10 9 11 14 6 10 22 15
Iphone 54 126 145 173 186 198 189 191 117 178 200 117
Mouse 8 14 14 19 27 24 30 44 18 39 39 23
New macbook charger 76 208 263 275 307 254 264 306 157 283 322 228
Non-graphing calc 0 5 10 22 32 25 24 31 13 5 9 61
Old macbook charger 16 52 86 83 64 70 59 64 26 56 61 31
Superdrive 1 3 4 2 2 2 6 6 0 4 0 4
VGA 17 54 66 72 91 65 54 78 33 101 45 15
VGA cable 8 16 19 21 24 15 15 23 8 29 6 4
Wall 0 9 11 16 23 30 34 32 21 37 30 20

c) Winter 2018 by Week

Winter 2018 Item Checkouts
Item Type Frequency
New macbook charger 2766
Iphone 2371
Expo 822
Headset 800
Old macbook charger 586
HDMI 552
VGA 512
Wall 445
Android 439
Non-graphing calc 215
Mouse 210
Hyperjuice 138
VGA cable 123
Superdrive 56
Graphing calc 52
Winter 2018 Item Checkouts by Week
0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week
Android 0 30 24 48 35 34 44 36 40 48 62 38
Expo 0 28 44 63 116 85 94 71 64 62 99 96
Graphing calc 0 1 1 2 8 6 5 6 10 2 4 7
HDMI 0 17 28 43 49 60 47 42 54 60 101 51
Headset 0 49 49 77 88 66 71 59 66 82 112 81
Hyperjuice 0 16 17 15 16 14 8 5 10 17 15 5
Iphone 0 132 144 216 190 202 211 166 238 319 356 197
Mouse 0 12 20 24 23 24 17 16 14 17 24 19
New macbook charger 0 182 212 276 286 277 251 250 280 251 334 167
Non-graphing calc 0 0 2 7 51 19 27 11 34 7 10 47
Old macbook charger 0 39 47 61 57 62 40 42 71 60 73 34
Superdrive 0 2 7 6 11 4 3 4 4 9 4 2
VGA 0 39 45 61 49 39 48 43 46 78 57 7
VGA cable 0 12 11 18 8 10 11 6 13 15 15 4
Wall 0 30 22 37 37 31 44 36 45 48 74 41

d) Spring 2018 by Week

Spring 2018 Item Checkouts
Item Type Frequency
Iphone 3536
New macbook charger 2508
Expo 786
Headset 785
Wall 650
Old macbook charger 629
VGA 615
HDMI 520
Android 431
Non-graphing calc 269
Mouse 257
Hyperjuice 195
VGA cable 143
Superdrive 68
Graphing calc 42
Spring 2018 Item Checkouts by Week
0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week
Android 0 32 35 30 45 44 44 34 42 38 50 37
Expo 0 25 37 67 76 87 86 93 59 55 87 114
Graphing calc 0 1 2 2 6 9 3 4 4 0 4 7
HDMI 0 36 22 30 53 54 44 56 56 62 77 30
Headset 0 44 58 62 66 74 67 64 66 80 111 93
Hyperjuice 0 19 20 16 18 22 20 22 18 10 16 14
Iphone 0 251 309 316 351 385 315 331 337 271 420 250
Mouse 0 17 26 18 16 31 20 21 24 17 41 26
New macbook charger 0 194 232 228 232 222 215 246 260 198 325 156
Non-graphing calc 0 2 1 18 34 39 30 25 31 6 32 51
Old macbook charger 0 45 58 42 67 66 49 61 64 50 96 31
Superdrive 0 3 4 9 2 13 1 4 14 6 12 0
VGA 0 51 58 64 60 58 60 76 56 61 57 14
VGA cable 0 20 10 13 14 15 16 19 12 14 9 1
Wall 0 43 48 55 52 47 53 74 71 40 101 66

e) Summer 2018

Note: Summer does not have item usage broken down by week because there are two summer sessions going on.

Summer 2018 Item Checkouts
Item Type Frequency
Iphone 1008
New macbook charger 889
Wall 413
Expo 297
Headset 276
VGA 213
HDMI 116
Android 108
Old macbook charger 101
Mouse 71
Non-graphing calc 38
VGA cable 26
Superdrive 20
Graphing calc 9
Hyperjuice 2

f) Fall 2018 by Week

Fall 2018 Item Checkouts
Item Type Frequency
Iphone 4981
New macbook charger 4312
Wall 1278
USBC macbook charger 946
Expo 894
Headset 893
VGA 713
HDMI 632
Android 515
Old macbook charger 430
Mouse 218
Non-graphing calc 151
VGA cable 145
Graphing calc 43
Superdrive 33
Livescribe pen 21
Fall 2018 Item Checkouts by Week
0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week
Android 19 36 43 42 41 46 52 59 23 53 64 37
Expo 16 39 45 75 104 87 94 93 50 85 100 106
Graphing calc 0 1 1 7 10 4 6 5 1 0 1 7
HDMI 15 41 37 60 78 63 57 70 31 69 78 33
Headset 28 66 63 77 100 87 78 66 31 70 120 107
Iphone 185 364 425 430 487 452 514 424 260 511 619 310
Livescribe pen 12 6 0 0 0 0 1 0 0 2 0 0
Mouse 12 20 19 19 14 15 16 11 8 20 38 26
New macbook charger 79 303 345 402 428 452 422 378 186 473 557 287
Non-graphing calc 3 3 7 8 14 17 20 9 6 5 19 40
Old macbook charger 8 22 36 52 38 49 56 40 18 30 55 26
Superdrive 5 2 6 1 5 3 2 3 2 3 1 0
USBC macbook charger 5 51 40 55 96 96 102 83 52 131 160 75
VGA 24 71 83 77 71 75 78 61 23 69 74 7
VGA cable 4 23 17 21 10 8 15 11 8 14 14 0
Wall 57 111 113 116 112 103 122 111 59 135 150 89

2.) Who is borrowing items?

a) Patron Types

Fall 2017-2018 Item Usage by Patron Type
UCLA Graduate UCLA Staff UCLA Undergraduate
Android 268 50 1681
Expo 1059 51 2775
Graphing calc 22 2 184
HDMI 602 135 1617
Headset 894 145 2523
Hyperjuice 110 2 331
Iphone 2243 233 11294
Livescribe pen 8 0 13
Mouse 459 215 381
New macbook charger 3492 254 9672
Non-graphing calc 99 13 798
Old macbook charger 665 56 1693
Superdrive 82 30 99
USBC macbook charger 127 28 791
VGA 1324 225 1195
VGA cable 285 46 294
Wall 659 73 2317

b) Individual Patrons

Note: The datasets for fall 2017 and winter 2018 have more than 50% null values for the patron ID, so they are excluded in the following table.

Number of Individual Patrons per Quarter
Total_Individual_Patrons
Spring 2018 3894
Summer 2018 1260
Fall 2018 4539

3) When and where are people borrowing from?

a) Item Usage by Location

Checkouts by Location
Var1 Freq
CLICC Lab 15816
CLICC YRL 15515
CLICC Powell 11220
CLICC Biomed 5661
CLICC SEL Boelter 1472
CLICC Arts 969
CLICC SEL Geology 666
CLICC Music 258
CLICC Classrooms 37

Item Usage by Location
CLICC Lab CLICC Powell CLICC YRL CLICC Biomed CLICC SEL Boelter CLICC Arts CLICC SEL Geology CLICC Music CLICC Classrooms
Android 953 430 476 59 69 0 12 0 0
Expo 312 899 2674 0 0 0 0 0 0
Graphing calc 208 0 0 0 0 0 0 0 0
HDMI 0 206 2057 65 25 0 1 0 0
Headset 864 1646 0 595 112 255 51 3 36
Hyperjuice 5 0 438 0 0 0 0 0 0
Iphone 6611 1852 3862 625 619 0 201 0 0
Livescribe pen 0 21 0 0 0 0 0 0 0
Mouse 0 230 316 348 42 59 30 30 0
New macbook charger 2834 3984 3583 2274 0 460 229 54 0
Non-graphing calc 910 0 0 0 0 0 0 0 0
Old macbook charger 446 759 621 373 23 74 43 75 0
Superdrive 0 54 49 31 10 12 0 54 1
USBC macbook charger 352 339 255 0 0 0 0 0 0
VGA 238 662 985 606 134 109 4 6 0
VGA cable 53 138 199 184 15 0 0 36 0
Wall 2030 0 0 501 423 0 95 0 0

b) Time Analysis of Item Usage by Location and Week

We see that there is a consistent dip in checkouts during Week 8. This is likely indicative of when people are less worried about midterms or finals. Shown by the two peaks, the busiest weeks for accessory item checkouts are Week 4 and Week 10.